package com.hefeng.wx.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hefeng.wx.domain.CustomerManualWorkOrder;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.Map;

@Mapper
public interface GasResultMapper extends BaseMapper<CustomerManualWorkOrder> {

    @Select("select c.LIVE_PHOTOS, c.LIVE_VIDEO from customer_manual_work_order c where c.ID = #{workId} AND (c.WORK_STATUS = 4 OR c.WORK_STATUS = 5)")
    Map<String, Object> getPa(String workId);

    @Select("select c.LIVE_PHOTOS, c.LIVE_VIDEO from customer_manual_work_order c where c.ID = #{workId} AND c.WORK_STATUS = 2")
    Map<String, Object> getPb(String workId);
}
